Excel Office 365 (Windows): Basic Formulas

Excel Office 365 (Windows): Basic Formulas

• Inserting a formula using the function library
• Performing simple calculations
• Using automated formulas in a table
• Creating automated cumulative totals
• Inserting subtotals
• Counting cells in a range
• Ranking a value
• Rounding a number
• Using replacement formulas
• Converting number types
• Factorizing the results of a division
• Creating random values

The power of Excel Office 365 is the support provided for using formulas on your data. Learn how to work with formulas, including built-in formulas such as SUM and COUNT, perform rounding and ranking, and generate random numbers.

Excel Office 365 (Windows): Creating & Saving Workbooks

Excel Office 365 (Windows): Creating & Saving Workbooks

• Creating & opening a document
• Using document templates
• Managing your worksheets
• Saving your document
• Saving your document as a PDF
• Recovering unsaved documents
• Inserting headers & footers
• Setting your print area
• Adjusting your print page layout
• Printing your document
• Checking for compatibility issues
• Editing your document properties
• Checking for personal information in your document
• Creating an accessible document
• Protecting your document

In Excel, it's easy to create and save new workbooks. Learn how to create, manage, and save documents, insert headers and footers, edit your document properties, and protect your Excel workbooks from unwanted edits or use.

Excel Office 365 (Windows): Formatting Data

Excel Office 365 (Windows): Formatting Data

• Setting your data type
• Formatting your data
• Aligning your data
• Using colors
• Changing your cell style
• Using document themes
• Using formulas to modify your text case
• Creating a title
• Formatting a title
• Creating a table
• Resizing columns & rows
• Inserting columns & rows
• Inserting borders
• Transferring format styles

Formatting data makes it easier to see and work with. Discover how you can align data, use colors and themes, resize rows and columns, and insert tables and borders in Excel to change the presentation of your data.

Excel Office 365 (Windows): Getting Started

Excel Office 365 (Windows): Getting Started

• Finding & opening the application
• Exploring the Interface
• Using the zoom function
• Using the view modes
• Moving between documents

Excel for Office 365 is the spreadsheet application in the Microsoft Office 365 suite. Explore the interface and some of its features, including the ribbon, status bar, zoom, and various view modes.

Excel Office 365 (Windows): Illustrating Documents

Excel Office 365 (Windows): Illustrating Documents

• Inserting an image
• Inserting a screenshot
• Editing an image
• Inserting shapes
• Inserting icons
• Inserting a hyperlink
• Using Smart Lookup

An Excel for Office 365 worksheet can contain more than just numbers and text. Discover how to insert and edit images, screenshots, and shapes, insert hyperlinks, and use the new Smart Lookup feature.

Excel Office 365 (Windows): Inserting & Manipulating Data

Excel Office 365 (Windows): Inserting & Manipulating Data

• Selecting cells
• Inputting data
• Inserting special characters
• Editing multiple worksheets simultaneously
• Deleting items in your spreadsheet
• Undoing & redoing actions
• Creating automatic data series
• Using the Flash Fill feature
• Inserting dropdown menus
• Using the spell check tool
• Configuring spell check & AutoCorrect options
• Transferring data
• Copying & pasting data
• Moving data from one worksheet to another
• Using the Paste Special tools
• Transposing a data range
• Consolidating your data

Excel contains a number of features to aid in data insertion and manipulation. Explore numerous ways to insert, edit, and manipulate your data, including undo and redo, Flash Fill, spell check, and transposing a data range.

Excel Office 365 (Windows): Sharing & Collaborating on a Document

Excel Office 365 (Windows): Sharing & Collaborating on a Document

• Sending your document via email
• Sharing your workbook via a link
• Managing link access & permissions
• Saving your documents to OneDrive
• Managing a workbook's version history
• Commenting on a document
• Collaborating on an Excel document
• Following & tracking document changes

Excel for Office 365 enables you to easily share your documents via email or upload them to OneDrive and SharePoint to collaborate with your team. This version of Excel also comes with a chat feature to communicate with others in real-time.

Excel Office 365: Configuring Options & Settings

Excel Office 365: Configuring Options & Settings

• view and configure connected account and services in Excel
• view and configure Add-ins in Excel
• create, save and reuse a custom template
• configure user and input behavior in Excel
• change default formula and calculation settings in Excel
• change the workbook default settings in Excel
• customize the way in which workbooks are saved in Excel
• customize the appearance of the Excel application
• customize the Quick Access Toolbar and its commands
• Customize the Office Ribbon and its commands

Get more out of Excel by customizing it to your own needs. Learn how to manage your account, connected services, and add-ins; configure input, template, and formula options; and customize the interface, ribbon, and Quick Access Toolbar.

Excel Office 365: Creating & Editing Macros

Excel Office 365: Creating & Editing Macros

• identify the key components of a macro
• create, edit and remove modules
• insert procedures into your macro modules
• write code in Visual Basic
• declare variables and insert constants
• insert objects and create object collections
• insert and test operators
• execute actions under conditions
• create events
• manage and correct macro errors

In Excel for Office 365 you can use the Visual Basic Editor to create and manage your macros. It's important to identify the key objects in your macro in order to start writing code for your Excel document.

In this course you will see how to insert procedures and start writing code. You will also see how to use objects and even create events to interact with those objects. Once you start writing code it's important to know how to identify and correct errors found in your code.

Excel Office 365: Creating Charts & Graphics

Excel Office 365: Creating Charts & Graphics

• insert , edit and remove charts
• insert charts quickly
• customize chart labels
• format a chart
• customize chart elements
• customize chart axes
• create a chart template
• present negative values in a chart
• insert trendlines
• customize trendlines

Analyze and present your data in a visually attractive manner in Excel for Office 365. Learn how to insert and customize charts, create chart templates, work with different chart types, and use trendlines.

Excel Office 365: Custom & Conditional Formatting

Excel Office 365: Custom & Conditional Formatting

• format currency, percentage and phone numbers with data values
• change your text format by adding or modifying a text elements appearance
• change your text format by adding or modifying a text elements appearance
• create custom color formatting for data entries
• apply conditional custom formatting to data values
• create conditional format rules to enhance your data values display
• use conditional formatting to highlight data in cells, rows and columns
• use conditional formatting tools to analyze your data further
• use advanced conditional formatting tools to find duplicate values or hide values
• organize conditional formatting rules applied to a worksheet

To customize data, you can use the built-in formats in Excel for Office 365, or you can use your own. Learn how to create custom formats for numbers, text, and date and time, as well as how to create and use conditional formatting.

Excel Office 365: Finding & Analyzing Information with Formulas

Excel Office 365: Finding & Analyzing Information with Formulas

• extract date values and perform calculations using dates
• retrieve information relating to dates in the past, present, and future
• use ranking formulas to find smallest and largest values in a list
• extract data and separate values into separate cells in Excel
• combine existing data values in a single cell in Excel
• analyze complex tables with multiple arrays to obtain a summarized result
• use the VLOOKUP and HLOOKUP formulas to cross-reference data lists and check for missing values
• use conditional formulas to perform a search across multiple tables and automatically insert data
• use the VLOOKUP formula to cross-reference data lists and retrieve corresponding values

There is a wide variety of tools that can be used to retrieve, return, and calculate data in Excel. See how to retrieve date information and rank values, retrieve, combine and separate data that is already available, and automate and simplify calculations using look-up tools and SUMPRODUCT.

Excel Office 365: Finding & Grouping Data

Excel Office 365: Finding & Grouping Data

• use the Find tools to jump to locations in a worksheet and find items with basic search queries
• use the advanced Find tools to customize and refine search queries
• use the Selection tools to locate and select graphical objects in a worksheet
• use the Replace tools to replace cell contents and formats
• use the Find and Replace tools when working specifically with formulas
• use the Freeze tools to change the view settings within a worksheet
• group rows and columns in a worksheet and control their display
• use the Group tools to create Outlines in a worksheet

Excel for Office 365 includes a number of methods for locating, displaying and manipulating data entries. Learn how to work with specific data using the Find and Replace tools, and manipulate data with the Group and Outline tools.

Excel Office 365: Forecasting & Solving Problems

Excel Office 365: Forecasting & Solving Problems

• identify formula errors
• check for and evaluate formulas in a workbook
• insert and visualise dynamic geographical and stock-related data in a worksheet
• use formulas to estimate loan-related costs
• use the Goal Seek tool to modify a data variable and reach a target value
• use the Solver add-in to analyze constraints and variables and optimize data values
• insert a Forecast worksheet to display trends and predictions based on available historic data
• use Data Tables to create what if, variable-based scenarios

Go further with you Excel document through understanding potential formula errors, use intelligent data types, set goals to reach targets as well as problem solve with the solver and Forecast tools offered by Excel for Office 365.

Excel Office 365: Getting to Know Macros in Excel

Excel Office 365: Getting to Know Macros in Excel

• record macros
• save a workbook with macros
• identify and use the key macro tools
• navigate and discover the VBA Editor interface
• run macros within Excel
• manage macros
• edit macros
• enable macros in a workbook
• manage macro security options
• use macros across multiple workbooks

If you have tasks in Excel Office 365 that you do repeatedly, you can record a macro to automate those tasks. A macro is an action or a set of actions that you can run as many times as you want. When you create a macro, you are recording your mouse clicks and keystrokes.

After you create a macro, you can edit it to make minor changes to the way it works. Macros and VBA tools can be found on the Developer tab, which is hidden by default, so the first step is to enable it. Once enabled, you'll be able to locate the VBA Editor as well as other key tools for managing macros in Excel.

Excel Office 365: Inserting PivotTables

Excel Office 365: Inserting PivotTables

• insert a PivotTable
• edit the source data and field setup in a PivotTable
• use predefined styles and formatting tools to change the appearance of a PivotTable
• copy and move a PivotTable within a workbook
• use sort tools to change the display of data in a PivotTable
• use filter tools to show and hide data in a PivotTable
• use label and value filters to analyze data in a PivotTable
• use group tools to sort and analyze related data in a PivotTable
• use a Slicer to filter data in a PivotTable
• customize the behavior and appearance of a Slicer
• customize the behavior and appearance of a Slicer

Excel includes powerful tools to summarize, sort, count, and chart data. Learn how to create, edit, and format PivotTables, sort, filter, and group data, and work with slicers and timelines.

Excel Office 365: Managing Data

Excel Office 365: Managing Data

• import, edit and update data from a text file
• import, edit and update data from a .csv file
• use the LOOKUP, MATCH and INDEX functions to extract data
• run multiple conditions without nesting other functions
• calculate averages using one or more conditions
• calculate the smallest and the largest numbers that meet one or more criteria
• count cells that meet one or more criteria
• calculate the number of periods to pay a loan and forecast loan approval that meet one or more criteria

Excel offers a set of tools that allows you explore more in detail data analysis and complex formulae. If you need to work with data from other sources, you can import and edit data from a text and a .csv file.

In this course you'll see how to use different formulae to make calculations when you have multiple conditions imposed. You'll also be able to forecast data using the NPER function.

With complex formulae you can run calculations to discover the average numbers or the smallest or largest values depending on a settle of conditions, for example.

Excel Office 365: Referencing Data

Excel Office 365: Referencing Data

• reference cells in your Excel worksheet
• use data across multiple worksheets to reference data for formulas
• define absolute and relative cell references
• name data ranges to refer to date and facilitate calculations
• use the Name Manager to visualize, edit, and delete existing named ranges
• perform calculations using constant values
• use cell references indirectly
• monitor data entries for changes and errors
• activate and configure automatic updates
• use formula auditing tools to track data

Many times, you will use a cell value in a formula or another location. Discover absolute and relative cell references, using data across multiple worksheets, and formula auditing in Excel for Office 365.

Excel Office 365: Sorting & Filtering Data

Excel Office 365: Sorting & Filtering Data

• sort data in a worksheet according to a specific data type
• customize sort options when sorting data in a worksheet
• sort data using multiple criteria and sort levels
• create and use custom sort lists to sort data
• use column filters to filter data in a worksheet
• use column filters to apply multiple filters to data in a worksheet
• create filter arguments using text and number data types
• sort and filter data using colors applied to data
• use the advanced filter tools to filter and extract data
• use filter tools to hide duplicate values in a data range

The first step in analyzing the data in a worksheet is often with Excel's sorting and filtering tools. These tools help you to control what is displayed in your data range, and how the values are organized. See how to perform basic and more advanced sort operations, filter data using the Filter and column header tools, and manage color-tagged and duplicate entries.

Excel Office 365: Using Conditional Formulas

Excel Office 365: Using Conditional Formulas

• inserting a conditional sum formula
• inserting a conditional message formula
• performing complex conditional formulas
• creating multiple conditions
• using IF & OR in conditional formulas
• using conditional formulas to count up value occurrences
• using reference positions in conditional formulas
• keeping your table up to date with conditional formulas

Conditional formulas let you perform a calculation on a range of values by specifying the criteria the data must meet. Discover how to use built-in conditional formulas and create your own.

Excel Office 365: Working with Data in PivotTables

Excel Office 365: Working with Data in PivotTables

• use a PivotTable to find trends and drill into data
• use the Data Model to work with data from multiple tables
• import existing database tables into the Data Model and use them in a PivotTable
• add Calculated Items and Calculated Fields to a PivotTable
• use the Value tools to and summary and comparison calculations
• visualize data from a PivotTable in a PivotChart
• customize and format a PivotChart
• configure and customize a PivotTable's display and control settings

Once your Excel PivotTables have been created you'll need to know how to manage and work with the data contained within. See how to analyze, calculate, collaborate and more with Excel PivotTables.

Excel Office 365: Working with Different Chart Styles

Excel Office 365: Working with Different Chart Styles

• insert and edit a Pie chart
• create and edit a Scatter chart
• create and edit a bubble chart
• create and edit a radar chart
• combine two types of chart using the Combo chart
• create and edit a Map chart

Excel offers a huge variety of different chart types and styles for presenting and analyzing your data in attractive and interesting ways. Learn how to insert, format, and manipulate Pie, Radar, Scatter, Bubble, Map, and Combo charts.

Excel Office 365: Working with Excel Tables

Excel Office 365: Working with Excel Tables

• convert a data range into an Excel table and edits its contents
• perform calculations and manipulate data in an Excel table
• use the formatting tools and styles to change the appearance of a table
• customize the table settings and tools
• use slicers to filter data in an Excel table
• resize and format a slicer

Excel tables are a useful tool for quickly managing, analyzing, and manipulating data in a range. Once configured as a table, you can easily sort, filter, and perform calculations on your data as well as change its appearance and formatting.

Excel Office 365: Working with Macros in Excel

Excel Office 365: Working with Macros in Excel

• insert, format and remover UserForms
• customize a form's size, color and alignment
• program a form to perform actions
• create actions to track changes in macros
• insert a macro function as a formula
• format text using macros
• calculate formatted values with macros
• export charts using macros

If you are using your Excel worksheet to input data, you can create form to fill out you worksheets more easily. With the VBA editor you can insert, edit and customize your forms to make inputting data easier for your users.

Excel for Office 365 also gives you the possibility to use macros within formulas. You can use macros in formulas to format text, perform calculations and even export charts to easily share or present to others.